Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 28944 |
| Missing cells | 42099 |
| Missing cells (%) | 7.7% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.2 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Unsupported | 3 |
|---|---|
| Numeric | 8 |
| Categorical | 3 |
| DateTime | 5 |
id is highly overall correlated with crmUserId and 2 other fields | High correlation |
crmId is highly overall correlated with crmOrgId and 1 other fields | High correlation |
crmUserId is highly overall correlated with id and 3 other fields | High correlation |
crmOrgId is highly overall correlated with crmId and 1 other fields | High correlation |
companyId is highly overall correlated with id and 2 other fields | High correlation |
crmValue is highly overall correlated with crmPipelineId | High correlation |
crmCustomerId is highly overall correlated with crmId and 1 other fields | High correlation |
crmPipelineId is highly overall correlated with id and 3 other fields | High correlation |
crmValueCurrency is highly overall correlated with crmUserId | High correlation |
isDeleted is highly imbalanced (88.9%) | Imbalance |
crmValueCurrency is highly imbalanced (87.0%) | Imbalance |
crmOrgId has 923 (3.2%) missing values | Missing |
crmWonTime has 25891 (89.5%) missing values | Missing |
crmCustomerId has 5907 (20.4%) missing values | Missing |
crmLostTime has 9124 (31.5%) missing values | Missing |
id is uniformly distributed | Uniform |
id has unique values | Unique |
_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
crmTitle is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
crmFormattedWeightedValue is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
crmValue has 10484 (36.2%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-20 10:33:13.265369 |
|---|---|
| Analysis finished | 2023-06-20 10:33:22.677421 |
| Duration | 9.41 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
_id
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
id
Real number (ℝ)
HIGH CORRELATION UNIFORM UNIQUE
| Distinct | 28944 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14540.191 |
| Minimum | 1 |
|---|---|
| Maximum | 29084 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1448.15 |
| Q1 | 7236.75 |
| median | 14585.5 |
| Q3 | 21828.25 |
| 95-th percentile | 27621.85 |
| Maximum | 29084 |
| Range | 29083 |
| Interquartile range (IQR) | 14591.5 |
Descriptive statistics
| Standard deviation | 8407.2488 |
|---|---|
| Coefficient of variation (CV) | 0.57820758 |
| Kurtosis | -1.2051592 |
| Mean | 14540.191 |
| Median Absolute Deviation (MAD) | 7296 |
| Skewness | -0.0016027691 |
| Sum | 4.2085129 × 108 |
| Variance | 70681832 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 19395 | 1 | < 0.1% |
| 19421 | 1 | < 0.1% |
| 19420 | 1 | < 0.1% |
| 19419 | 1 | < 0.1% |
| 19418 | 1 | < 0.1% |
| 19417 | 1 | < 0.1% |
| 19416 | 1 | < 0.1% |
| 19415 | 1 | < 0.1% |
| 19414 | 1 | < 0.1% |
| Other values (28934) | 28934 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 29084 | 1 | |
| 29083 | 1 | |
| 29082 | 1 | |
| 29081 | 1 | |
| 29080 | 1 | |
| 29079 | 1 | |
| 29078 | 1 | |
| 29077 | 1 | |
| 29076 | 1 | |
| 29075 | 1 |
crmId
Real number (ℝ)
| Distinct | 14374 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5596.6884 |
| Minimum | 1 |
|---|---|
| Maximum | 18140 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 155 |
| Q1 | 1175 |
| median | 4117.5 |
| Q3 | 8067 |
| 95-th percentile | 16608.85 |
| Maximum | 18140 |
| Range | 18139 |
| Interquartile range (IQR) | 6892 |
Descriptive statistics
| Standard deviation | 5149.5815 |
|---|---|
| Coefficient of variation (CV) | 0.92011223 |
| Kurtosis | -0.27131536 |
| Mean | 5596.6884 |
| Median Absolute Deviation (MAD) | 3360.5 |
| Skewness | 0.88955501 |
| Sum | 1.6199055 × 108 |
| Variance | 26518190 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 245 | 14 | < 0.1% |
| 261 | 13 | < 0.1% |
| 332 | 13 | < 0.1% |
| 342 | 13 | < 0.1% |
| 341 | 13 | < 0.1% |
| 30 | 13 | < 0.1% |
| 33 | 13 | < 0.1% |
| 336 | 13 | < 0.1% |
| 335 | 13 | < 0.1% |
| 331 | 13 | < 0.1% |
| Other values (14364) | 28813 |
| Value | Count | Frequency (%) |
| 1 | 12 | |
| 2 | 13 | |
| 3 | 11 | |
| 4 | 10 | |
| 5 | 12 | |
| 6 | 12 | |
| 7 | 11 | |
| 8 | 9 | |
| 9 | 13 | |
| 10 | 11 |
| Value | Count | Frequency (%) |
| 18140 | 1 | |
| 18139 | 1 | |
| 18138 | 1 | |
| 18137 | 1 | |
| 18136 | 1 | |
| 18135 | 1 | |
| 18134 | 1 | |
| 18133 | 1 | |
| 18132 | 1 | |
| 18131 | 1 |
crmUserId
Real number (ℝ)
| Distinct | 107 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10390270 |
| Minimum | 519660 |
|---|---|
| Maximum | 15168007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 519660 |
|---|---|
| 5-th percentile | 1312133 |
| Q1 | 9621004 |
| median | 11861022 |
| Q3 | 12182940 |
| 95-th percentile | 13410041 |
| Maximum | 15168007 |
| Range | 14648347 |
| Interquartile range (IQR) | 2561936 |
Descriptive statistics
| Standard deviation | 3624417.1 |
|---|---|
| Coefficient of variation (CV) | 0.34882798 |
| Kurtosis | 1.4741446 |
| Mean | 10390270 |
| Median Absolute Deviation (MAD) | 530494 |
| Skewness | -1.6288246 |
| Sum | 3.0073599 × 1011 |
| Variance | 1.3136399 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 12164637 | 1792 | 6.2% |
| 13188567 | 1557 | 5.4% |
| 11490668 | 1523 | 5.3% |
| 9621004 | 1237 | 4.3% |
| 1726230 | 1222 | 4.2% |
| 11353976 | 1202 | 4.2% |
| 11924103 | 1093 | 3.8% |
| 11490788 | 953 | 3.3% |
| 12182940 | 925 | 3.2% |
| 11330528 | 923 | 3.2% |
| Other values (97) | 16517 |
| Value | Count | Frequency (%) |
| 519660 | 750 | |
| 632315 | 16 | 0.1% |
| 686380 | 100 | 0.3% |
| 944589 | 7 | < 0.1% |
| 1194982 | 11 | < 0.1% |
| 1312133 | 630 | |
| 1347043 | 9 | < 0.1% |
| 1349827 | 10 | < 0.1% |
| 1726230 | 1222 | |
| 1954927 | 162 | 0.6% |
| Value | Count | Frequency (%) |
| 15168007 | 361 | |
| 14344370 | 1 | < 0.1% |
| 14297763 | 1 | < 0.1% |
| 14284464 | 22 | 0.1% |
| 14211842 | 66 | 0.2% |
| 14115845 | 5 | < 0.1% |
| 14115834 | 6 | < 0.1% |
| 13755914 | 8 | < 0.1% |
| 13755903 | 9 | < 0.1% |
| 13755892 | 3 | < 0.1% |
crmOrgId
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 15513 |
|---|---|
| Distinct (%) | 55.4% |
| Missing | 923 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15220.434 |
| Minimum | 1 |
|---|---|
| Maximum | 48788 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 65 |
| Q1 | 1920 |
| median | 11148 |
| Q3 | 26392 |
| 95-th percentile | 43001 |
| Maximum | 48788 |
| Range | 48787 |
| Interquartile range (IQR) | 24472 |
Descriptive statistics
| Standard deviation | 14103.764 |
|---|---|
| Coefficient of variation (CV) | 0.92663353 |
| Kurtosis | -0.85494736 |
| Mean | 15220.434 |
| Median Absolute Deviation (MAD) | 9883 |
| Skewness | 0.65294658 |
| Sum | 4.2649178 × 108 |
| Variance | 1.9891617 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 60 | 0.2% |
| 3 | 43 | 0.1% |
| 8 | 42 | 0.1% |
| 42 | 37 | 0.1% |
| 16 | 36 | 0.1% |
| 528 | 36 | 0.1% |
| 30 | 35 | 0.1% |
| 84 | 35 | 0.1% |
| 5 | 31 | 0.1% |
| 46 | 31 | 0.1% |
| Other values (15503) | 27635 | |
| (Missing) | 923 | 3.2% |
| Value | Count | Frequency (%) |
| 1 | 60 | |
| 2 | 11 | < 0.1% |
| 3 | 43 | |
| 4 | 23 | 0.1% |
| 5 | 31 | |
| 6 | 19 | 0.1% |
| 7 | 25 | |
| 8 | 42 | |
| 9 | 25 | |
| 10 | 29 |
| Value | Count | Frequency (%) |
| 48788 | 3 | |
| 48787 | 1 | < 0.1% |
| 48786 | 1 | < 0.1% |
| 48785 | 1 | < 0.1% |
| 48781 | 2 | |
| 48780 | 1 | < 0.1% |
| 48779 | 1 | < 0.1% |
| 48778 | 1 | < 0.1% |
| 48777 | 1 | < 0.1% |
| 48776 | 2 |
crmTitle
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
crmStatus
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| lost | |
|---|---|
| open | |
| won | |
| deleted | 33 |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 3.8979754 |
| Min length | 3 |
Characters and Unicode
| Total characters | 112823 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | lost |
|---|---|
| 2nd row | lost |
| 3rd row | won |
| 4th row | won |
| 5th row | lost |
Common Values
| Value | Count | Frequency (%) |
| lost | 19825 | |
| open | 6034 | 20.8% |
| won | 3052 | 10.5% |
| deleted | 33 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lost | 19825 | |
| open | 6034 | 20.8% |
| won | 3052 | 10.5% |
| deleted | 33 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 28911 | |
| l | 19858 | |
| t | 19858 | |
| s | 19825 | |
| n | 9086 | 8.1% |
| e | 6133 | 5.4% |
| p | 6034 | 5.3% |
| w | 3052 | 2.7% |
| d | 66 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 112823 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 28911 | |
| l | 19858 | |
| t | 19858 | |
| s | 19825 | |
| n | 9086 | 8.1% |
| e | 6133 | 5.4% |
| p | 6034 | 5.3% |
| w | 3052 | 2.7% |
| d | 66 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 112823 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 28911 | |
| l | 19858 | |
| t | 19858 | |
| s | 19825 | |
| n | 9086 | 8.1% |
| e | 6133 | 5.4% |
| p | 6034 | 5.3% |
| w | 3052 | 2.7% |
| d | 66 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 112823 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 28911 | |
| l | 19858 | |
| t | 19858 | |
| s | 19825 | |
| n | 9086 | 8.1% |
| e | 6133 | 5.4% |
| p | 6034 | 5.3% |
| w | 3052 | 2.7% |
| d | 66 | 0.1% |
crmWonTime
Date
| Distinct | 2807 |
|---|---|
| Distinct (%) | 91.9% |
| Missing | 25891 |
| Missing (%) | 89.5% |
| Memory size | 226.2 KiB |
| Minimum | 2015-03-12 12:35:15 |
|---|---|
| Maximum | 2022-06-08 15:00:30 |
Histogram with fixed size bins (bins=50)
crmUpdateTime
Date
| Distinct | 11896 |
|---|---|
| Distinct (%) | 41.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| Minimum | 2017-12-11 11:34:22 |
|---|---|
| Maximum | 2022-06-09 06:13:11 |
Histogram with fixed size bins (bins=50)
crmAddTime
Date
| Distinct | 24428 |
|---|---|
| Distinct (%) | 84.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| Minimum | 2015-03-03 17:01:37 |
|---|---|
| Maximum | 2022-06-08 17:35:00 |
Histogram with fixed size bins (bins=50)
crmFormattedWeightedValue
Unsupported
REJECTED UNSUPPORTED
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
isDeleted
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| 0 | |
|---|---|
| 1 | 427 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 28944 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 28944 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 28944 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 28944 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 28517 | |
| 1 | 427 | 1.5% |
createDate
Date
| Distinct | 1836 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 226.2 KiB |
| Minimum | 2022-01-27 14:13:05 |
|---|---|
| Maximum | 2022-06-08 17:35:13 |
Histogram with fixed size bins (bins=50)
companyId
Real number (ℝ)
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.8009605 |
| Minimum | 2 |
|---|---|
| Maximum | 42 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 5 |
| median | 8 |
| Q3 | 16 |
| 95-th percentile | 16 |
| Maximum | 42 |
| Range | 40 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 5.6686188 |
|---|---|
| Coefficient of variation (CV) | 0.5783738 |
| Kurtosis | 3.6177047 |
| Mean | 9.8009605 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.4041138 |
| Sum | 283679 |
| Variance | 32.133239 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 5 | 10491 | |
| 16 | 7816 | |
| 12 | 2222 | 7.7% |
| 8 | 2062 | 7.1% |
| 9 | 2029 | 7.0% |
| 6 | 1031 | 3.6% |
| 7 | 792 | 2.7% |
| 35 | 402 | 1.4% |
| 14 | 361 | 1.2% |
| 11 | 340 | 1.2% |
| Other values (8) | 1398 | 4.8% |
| Value | Count | Frequency (%) |
| 2 | 340 | 1.2% |
| 3 | 340 | 1.2% |
| 4 | 340 | 1.2% |
| 5 | 10491 | |
| 6 | 1031 | 3.6% |
| 7 | 792 | 2.7% |
| 8 | 2062 | 7.1% |
| 9 | 2029 | 7.0% |
| 11 | 340 | 1.2% |
| 12 | 2222 | 7.7% |
| Value | Count | Frequency (%) |
| 42 | 13 | < 0.1% |
| 35 | 402 | 1.4% |
| 21 | 12 | < 0.1% |
| 19 | 1 | < 0.1% |
| 18 | 340 | 1.2% |
| 16 | 7816 | |
| 14 | 361 | 1.2% |
| 13 | 12 | < 0.1% |
| 12 | 2222 | 7.7% |
| 11 | 340 | 1.2% |
crmValue
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 3071 |
|---|---|
| Distinct (%) | 10.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26368.683 |
| Minimum | 0 |
|---|---|
| Maximum | 1638000 |
| Zeros | 10484 |
| Zeros (%) | 36.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4250.5 |
| Q3 | 30000 |
| 95-th percentile | 120000 |
| Maximum | 1638000 |
| Range | 1638000 |
| Interquartile range (IQR) | 30000 |
Descriptive statistics
| Standard deviation | 68785.343 |
|---|---|
| Coefficient of variation (CV) | 2.6085999 |
| Kurtosis | 119.11331 |
| Mean | 26368.683 |
| Median Absolute Deviation (MAD) | 4250.5 |
| Skewness | 8.540317 |
| Sum | 7.6321516 × 108 |
| Variance | 4.7314235 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 10484 | |
| 30000 | 3658 | 12.6% |
| 36000 | 3201 | 11.1% |
| 42000 | 462 | 1.6% |
| 7164 | 351 | 1.2% |
| 3564 | 213 | 0.7% |
| 800 | 210 | 0.7% |
| 14364 | 172 | 0.6% |
| 10000 | 163 | 0.6% |
| 68 | 134 | 0.5% |
| Other values (3061) | 9896 |
| Value | Count | Frequency (%) |
| 0 | 10484 | |
| 1 | 88 | 0.3% |
| 2 | 6 | < 0.1% |
| 3 | 6 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1638000 | 2 | |
| 1495200 | 2 | |
| 1388400 | 2 | |
| 1362000 | 4 | |
| 1281600 | 2 | |
| 1141308 | 4 | |
| 1088400 | 2 | |
| 1014600 | 2 | |
| 993600 | 2 | |
| 985764 | 2 |
crmValueCurrency
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 226.2 KiB |
| EUR | |
|---|---|
| USD | 523 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 86826 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EUR |
|---|---|
| 2nd row | EUR |
| 3rd row | EUR |
| 4th row | EUR |
| 5th row | EUR |
Common Values
| Value | Count | Frequency (%) |
| EUR | 28419 | |
| USD | 523 | 1.8% |
| (Missing) | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| eur | 28419 | |
| usd | 523 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 28942 | |
| E | 28419 | |
| R | 28419 | |
| S | 523 | 0.6% |
| D | 523 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 86826 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 28942 | |
| E | 28419 | |
| R | 28419 | |
| S | 523 | 0.6% |
| D | 523 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 86826 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 28942 | |
| E | 28419 | |
| R | 28419 | |
| S | 523 | 0.6% |
| D | 523 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86826 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 28942 | |
| E | 28419 | |
| R | 28419 | |
| S | 523 | 0.6% |
| D | 523 | 0.6% |
crmCustomerId
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 16530 |
|---|---|
| Distinct (%) | 71.8% |
| Missing | 5907 |
| Missing (%) | 20.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20568.551 |
| Minimum | 1 |
|---|---|
| Maximum | 50852 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 470 |
| Q1 | 7811 |
| median | 21613 |
| Q3 | 29803 |
| 95-th percentile | 45754.8 |
| Maximum | 50852 |
| Range | 50851 |
| Interquartile range (IQR) | 21992 |
Descriptive statistics
| Standard deviation | 14015.495 |
|---|---|
| Coefficient of variation (CV) | 0.68140409 |
| Kurtosis | -0.91295644 |
| Mean | 20568.551 |
| Median Absolute Deviation (MAD) | 10150 |
| Skewness | 0.20382215 |
| Sum | 4.738377 × 108 |
| Variance | 1.9643409 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 33 | 0.1% |
| 2405 | 25 | 0.1% |
| 2332 | 19 | 0.1% |
| 35081 | 17 | 0.1% |
| 24727 | 17 | 0.1% |
| 13812 | 16 | 0.1% |
| 3 | 14 | < 0.1% |
| 22387 | 14 | < 0.1% |
| 603 | 13 | < 0.1% |
| 118 | 12 | < 0.1% |
| Other values (16520) | 22857 | |
| (Missing) | 5907 | 20.4% |
| Value | Count | Frequency (%) |
| 1 | 33 | |
| 2 | 4 | < 0.1% |
| 3 | 14 | |
| 4 | 8 | < 0.1% |
| 5 | 11 | < 0.1% |
| 6 | 7 | < 0.1% |
| 7 | 7 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 7 | < 0.1% |
| 10 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 50852 | 1 | |
| 50851 | 1 | |
| 50850 | 1 | |
| 50842 | 1 | |
| 50832 | 1 | |
| 50821 | 1 | |
| 50820 | 1 | |
| 50814 | 1 | |
| 50813 | 1 | |
| 50812 | 1 |
crmLostTime
Date
| Distinct | 13938 |
|---|---|
| Distinct (%) | 70.3% |
| Missing | 9124 |
| Missing (%) | 31.5% |
| Memory size | 226.2 KiB |
| Minimum | 2015-04-28 14:47:15 |
|---|---|
| Maximum | 2022-06-08 15:41:26 |
Histogram with fixed size bins (bins=50)
crmPipelineId
Real number (ℝ)
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 252 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.736024 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 226.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 5 |
| Q3 | 8 |
| 95-th percentile | 18 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.1384398 |
|---|---|
| Coefficient of variation (CV) | 0.8958191 |
| Kurtosis | 0.88193255 |
| Mean | 5.736024 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 1.0929296 |
| Sum | 164578 |
| Variance | 26.403564 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 1 | 11483 | |
| 8 | 6960 | |
| 9 | 3936 | 13.6% |
| 5 | 1368 | 4.7% |
| 20 | 1042 | 3.6% |
| 18 | 1031 | 3.6% |
| 2 | 967 | 3.3% |
| 7 | 579 | 2.0% |
| 3 | 428 | 1.5% |
| 4 | 261 | 0.9% |
| Other values (5) | 637 | 2.2% |
| (Missing) | 252 | 0.9% |
| Value | Count | Frequency (%) |
| 1 | 11483 | |
| 2 | 967 | 3.3% |
| 3 | 428 | 1.5% |
| 4 | 261 | 0.9% |
| 5 | 1368 | 4.7% |
| 6 | 198 | 0.7% |
| 7 | 579 | 2.0% |
| 8 | 6960 | |
| 9 | 3936 | 13.6% |
| 11 | 61 | 0.2% |
| Value | Count | Frequency (%) |
| 20 | 1042 | 3.6% |
| 19 | 113 | 0.4% |
| 18 | 1031 | 3.6% |
| 16 | 63 | 0.2% |
| 12 | 202 | 0.7% |
| 11 | 61 | 0.2% |
| 9 | 3936 | |
| 8 | 6960 | |
| 7 | 579 | 2.0% |
| 6 | 198 | 0.7% |
| id | crmId | crmUserId | crmOrgId | companyId | crmValue | crmCustomerId | crmPipelineId | crmStatus | isDeleted | crmValueCurrency | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | -0.198 | 0.802 | 0.065 | 0.851 | 0.408 | 0.025 | -0.585 | 0.297 | 0.165 | 0.305 |
| crmId | -0.198 | 1.000 | -0.214 | 0.674 | -0.303 | -0.139 | 0.742 | 0.424 | 0.201 | 0.313 | 0.178 |
| crmUserId | 0.802 | -0.214 | 1.000 | 0.047 | 0.653 | 0.418 | 0.019 | -0.619 | 0.262 | 0.082 | 0.625 |
| crmOrgId | 0.065 | 0.674 | 0.047 | 1.000 | 0.045 | -0.013 | 0.759 | 0.080 | 0.163 | 0.285 | 0.122 |
| companyId | 0.851 | -0.303 | 0.653 | 0.045 | 1.000 | 0.384 | -0.117 | -0.564 | 0.208 | 0.079 | 0.356 |
| crmValue | 0.408 | -0.139 | 0.418 | -0.013 | 0.384 | 1.000 | 0.164 | -0.510 | 0.079 | 0.015 | 0.020 |
| crmCustomerId | 0.025 | 0.742 | 0.019 | 0.759 | -0.117 | 0.164 | 1.000 | 0.030 | 0.193 | 0.137 | 0.214 |
| crmPipelineId | -0.585 | 0.424 | -0.619 | 0.080 | -0.564 | -0.510 | 0.030 | 1.000 | 0.300 | 0.083 | 0.161 |
| crmStatus | 0.297 | 0.201 | 0.262 | 0.163 | 0.208 | 0.079 | 0.193 | 0.300 | 1.000 | 0.237 | 0.256 |
| isDeleted | 0.165 | 0.313 | 0.082 | 0.285 | 0.079 | 0.015 | 0.137 | 0.083 | 0.237 | 1.000 | 0.051 |
| crmValueCurrency | 0.305 | 0.178 | 0.625 | 0.122 | 0.356 | 0.020 | 0.214 | 0.161 | 0.256 | 0.051 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| _id | id | crmId | crmUserId | crmOrgId | crmTitle | crmStatus | crmWonTime | crmUpdateTime | crmAddTime | crmFormattedWeightedValue | isDeleted | createDate | companyId | crmValue | crmValueCurrency | crmCustomerId | crmLostTime | crmPipelineId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 64902efa7cc8b1037a60e09c | 1 | 1 | 1726230 | 78.0 | LOST - IGEL GmbH - BASIC42341 | lost | None | 2021-12-22 15:07:40 | 2015-03-03 17:01:37 | 24 € | 0 | 2022-01-27 14:13:05 | 5 | 120 | EUR | 119.0 | 2015-12-03 13:55:38 | 8.0 |
| 1 | 64902efa7cc8b1037a60e09d | 2 | 2 | 7456913 | 71.0 | OUT - Holy AG | lost | None | 2019-12-20 16:32:52 | 2015-03-04 07:48:10 | 0 € | 0 | 2022-01-27 14:13:05 | 5 | 0 | EUR | NaN | 2019-12-20 16:32:38 | 9.0 |
| 2 | 64902efa7cc8b1037a60e09e | 3 | 3 | 519660 | 46.0 | Jost Hurler - Schwabinger Tor App | won | 2015-06-19 09:58:24 | 2021-05-20 16:54:31 | 2015-03-04 08:46:13 | 60.000 € | 0 | 2022-01-27 14:13:05 | 5 | 60000 | EUR | 109.0 | None | 8.0 |
| 3 | 64902efa7cc8b1037a60e09f | 4 | 4 | 519660 | 68.0 | etcos GmbH - Pilotprogramm | won | 2015-03-12 12:35:15 | 2021-05-20 16:55:45 | 2015-03-04 08:49:21 | 0 € | 0 | 2022-01-27 14:13:05 | 5 | 0 | EUR | 108.0 | None | 8.0 |
| 4 | 64902efa7cc8b1037a60e0a0 | 5 | 5 | 9621004 | 88.0 | LOST - Wagnis e.G. - Wohnportal42122 | lost | None | 2021-12-22 15:17:37 | 2015-03-04 08:51:07 | 40 € | 0 | 2022-01-27 14:13:05 | 5 | 200 | EUR | 27.0 | 2015-04-28 14:47:15 | 8.0 |
| 5 | 64902efa7cc8b1037a60e0a1 | 6 | 6 | 519660 | 4.0 | Dr. Gerlich GmbH - Rollout | won | 2015-09-02 15:43:23 | 2021-05-20 16:56:06 | 2015-03-04 08:52:26 | 2.700 € | 0 | 2022-01-27 14:13:05 | 5 | 2700 | EUR | 88.0 | None | 8.0 |
| 6 | 64902efa7cc8b1037a60e0a2 | 7 | 7 | 519660 | 12484.0 | YOUNIQ AG - Pilotprogramm | won | 2015-05-23 13:52:28 | 2021-05-20 16:57:27 | 2015-03-04 08:55:49 | 0 € | 0 | 2022-01-27 14:13:05 | 5 | 0 | EUR | 30.0 | None | 8.0 |
| 7 | 64902efa7cc8b1037a60e0a3 | 8 | 9 | 686380 | 53.0 | VfFK - Rollout | won | 2015-10-30 16:41:34 | 2021-05-20 16:53:59 | 2015-03-04 09:00:21 | 120 € | 0 | 2022-01-27 14:13:05 | 5 | 120 | EUR | 84.0 | None | 8.0 |
| 8 | 64902efa7cc8b1037a60e0a4 | 9 | 10 | 9621004 | 2728.0 | LOST - Studiosus Studentenapartments - Outreach42591 | lost | None | 2021-12-22 15:17:16 | 2015-03-04 09:32:34 | 0 € | 0 | 2022-01-27 14:13:05 | 5 | 0 | EUR | 3562.0 | 2016-08-09 08:07:24 | 8.0 |
| 9 | 64902efa7cc8b1037a60e0a5 | 10 | 12 | 519660 | 138.0 | OUT - Südhausbau KG | won | 2018-11-23 14:40:40 | 2021-12-16 12:27:51 | 2015-03-05 10:17:18 | 15.444 € | 0 | 2022-01-27 14:13:05 | 5 | 15444 | EUR | 22437.0 | None | 8.0 |
| _id | id | crmId | crmUserId | crmOrgId | crmTitle | crmStatus | crmWonTime | crmUpdateTime | crmAddTime | crmFormattedWeightedValue | isDeleted | createDate | companyId | crmValue | crmValueCurrency | crmCustomerId | crmLostTime | crmPipelineId | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28934 | 64902efb7cc8b1037a6151a2 | 29075 | 18133 | 12042627 | 16654.0 | Aschoff Immobilien Ltd. deal | open | None | 2022-06-08 12:55:42 | 2022-06-08 12:47:06 | 712,80 € | 0 | 2022-06-08 12:48:53 | 5 | 3564 | EUR | 21111.0 | None | 8.0 |
| 28935 | 64902efb7cc8b1037a6151a3 | 29076 | 18134 | 11967795 | 33901.0 | Werner Sutter & Co. AG | open | None | 2022-06-08 13:06:16 | 2022-06-08 12:56:57 | 4.309,20 € | 0 | 2022-06-08 12:57:02 | 5 | 14364 | EUR | 48523.0 | None | 8.0 |
| 28936 | 64902efb7cc8b1037a6151a4 | 29077 | 18136 | 11967795 | 18517.0 | LMI Immobilien deal | open | None | 2022-06-08 13:36:22 | 2022-06-08 13:28:15 | 1.432,80 € | 0 | 2022-06-08 13:28:17 | 5 | 7164 | EUR | 50850.0 | None | 8.0 |
| 28937 | 64902efb7cc8b1037a6151a5 | 29078 | 18137 | 12654418 | 35556.0 | Euro Fashion Center Verwaltungs GmbH deal | open | None | 2022-06-08 15:20:10 | 2022-06-08 13:34:19 | 0 € | 0 | 2022-06-08 13:34:20 | 5 | 0 | EUR | 50852.0 | None | 8.0 |
| 28938 | 64902efb7cc8b1037a6151a6 | 29079 | 18138 | 13755892 | 20330.0 | Baugenossenschaft des Landkreises Coburg eG WOWIPORT (Frank & Viktoria) | open | None | 2022-06-08 14:12:04 | 2022-06-08 13:42:30 | 9.196,20 € | 0 | 2022-06-08 13:42:48 | 5 | 30654 | EUR | 48216.0 | None | 8.0 |
| 28939 | 64902efb7cc8b1037a6151a7 | 29080 | 18139 | 13755914 | 35557.0 | IN - ST.SH Immobilienservice GmbH | open | None | 2022-06-08 14:50:05 | 2022-06-08 14:16:07 | 0 € | 0 | 2022-06-08 14:16:10 | 5 | 0 | EUR | 7523.0 | None | 8.0 |
| 28940 | 64902efb7cc8b1037a6151a8 | 29081 | 18140 | 11967795 | 34823.0 | RE/MAX Immowest R. Götze GmbH | open | None | 2022-06-08 14:51:54 | 2022-06-08 14:42:57 | 1.069,20 € | 0 | 2022-06-08 14:51:26 | 5 | 3564 | EUR | 48449.0 | None | 8.0 |
| 28941 | 64902efb7cc8b1037a6151a9 | 29082 | 1068 | 12577002 | 1881.0 | Deecoob Technology Gmbh Lead | open | None | 2022-06-08 14:58:39 | 2022-06-08 14:58:37 | 179 € | 0 | 2022-06-08 14:58:41 | 7 | 179 | EUR | 1708.0 | None | 1.0 |
| 28942 | 64902efb7cc8b1037a6151aa | 29083 | 18135 | 12654418 | 35555.0 | [(Chatbot) - ] LBBW Immobilien Asset Management GmbH | open | None | 2022-06-08 15:52:50 | 2022-06-08 13:15:49 | 0 € | 0 | 2022-06-08 15:35:45 | 5 | 0 | EUR | 50851.0 | None | 8.0 |
| 28943 | 64902efb7cc8b1037a6151ab | 29084 | 2923 | 12024843 | 9175.0 | marta GmbH Deal | open | None | 2022-06-09 06:13:11 | 2022-06-08 17:35:00 | 0 € | 0 | 2022-06-08 17:35:13 | 12 | 0 | EUR | 19971.0 | None | 7.0 |